Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	932
Missing cells	4
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	94.8 KiB
Average record size in memory	104.1 B

Variable types

Text	2
Categorical	3
Numeric	7
DateTime	1

Alerts

`ItemType SalesChannel` is highly overall correlated with `Total` and 1 other fields	High correlation
`Revenue` is highly overall correlated with `Total` and 4 other fields	High correlation
`Total` is highly overall correlated with `ItemType SalesChannel` and 4 other fields	High correlation
`TotalCost` is highly overall correlated with `Revenue` and 4 other fields	High correlation
`TotalProfit` is highly overall correlated with `Revenue` and 4 other fields	High correlation
`UnitCost` is highly overall correlated with `ItemType SalesChannel` and 4 other fields	High correlation
`UnitPrice` is highly overall correlated with `Revenue` and 2 other fields	High correlation
`UnitsSold` has unique values	Unique

Reproduction

Analysis started	2024-08-12 17:10:28.824616
Analysis finished	2024-08-12 17:10:43.447645
Duration	14.62 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

Region
Text

Distinct	112
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Memory size	7.4 KiB

Length

Max length	51
Median length	48
Mean length	17.56867
Min length	4

Characters and Unicode

Total characters	16374
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	38 ?
Unique (%)	4.1%

Sample

1st row	Middle East and North Africa
2nd row	North America
3rd row	Middle East and North Africa
4th row	Asia
5th row	Sub-Saharan Africa

Value	Count	Frequency (%)
africa	374	16.1%
and	294	12.6%
north	135	5.8%
east	131	5.6%
america	107	4.6%
caribbean	92	3.9%
the	92	3.9%
central	92	3.9%
oceania	71	3.0%
0europe	30	1.3%
Other values (79)	912	39.1%

Most occurring characters

Value	Count	Frequency (%)
a	2332	14.2%
	1914	11.7%
r	1387	8.5%
i	988	6.0%
e	858	5.2%
n	806	4.9%
A	682	4.2%
u	564	3.4%
c	563	3.4%
d	558	3.4%
Other values (31)	5722	34.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	16374	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	2332	14.2%
	1914	11.7%
r	1387	8.5%
i	988	6.0%
e	858	5.2%
n	806	4.9%
A	682	4.2%
u	564	3.4%
c	563	3.4%
d	558	3.4%
Other values (31)	5722	34.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	16374	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	2332	14.2%
	1914	11.7%
r	1387	8.5%
i	988	6.0%
e	858	5.2%
n	806	4.9%
A	682	4.2%
u	564	3.4%
c	563	3.4%
d	558	3.4%
Other values (31)	5722	34.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	16374	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	2332	14.2%
	1914	11.7%
r	1387	8.5%
i	988	6.0%
e	858	5.2%
n	806	4.9%
A	682	4.2%
u	564	3.4%
c	563	3.4%
d	558	3.4%
Other values (31)	5722	34.9%

Country
Text

Distinct	190
Distinct (%)	20.4%
Missing	0
Missing (%)	0.0%
Memory size	7.4 KiB

Length

Max length	33
Median length	27
Mean length	8.5321888
Min length	4

Characters and Unicode

Total characters	7952
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	1.2%

Sample

1st row	Libya
2nd row	Canada
3rd row	Libya
4th row	Japan
5th row	Chad

Value	Count	Frequency (%)
republic	31	2.6%
and	23	1.9%
the	22	1.8%
of	19	1.6%
south	16	1.3%
sudan	15	1.3%
islands	14	1.2%
saint	12	1.0%
guinea	11	0.9%
congo	11	0.9%
Other values (207)	1025	85.5%

Most occurring characters

Value	Count	Frequency (%)
a	1206	15.2%
i	685	8.6%
n	623	7.8%
e	532	6.7%
o	413	5.2%
r	403	5.1%
l	316	4.0%
u	306	3.8%
t	299	3.8%
	270	3.4%
Other values (43)	2899	36.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7952	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1206	15.2%
i	685	8.6%
n	623	7.8%
e	532	6.7%
o	413	5.2%
r	403	5.1%
l	316	4.0%
u	306	3.8%
t	299	3.8%
	270	3.4%
Other values (43)	2899	36.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7952	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1206	15.2%
i	685	8.6%
n	623	7.8%
e	532	6.7%
o	413	5.2%
r	403	5.1%
l	316	4.0%
u	306	3.8%
t	299	3.8%
	270	3.4%
Other values (43)	2899	36.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7952	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1206	15.2%
i	685	8.6%
n	623	7.8%
e	532	6.7%
o	413	5.2%
r	403	5.1%
l	316	4.0%
u	306	3.8%
t	299	3.8%
	270	3.4%
Other values (43)	2899	36.5%

ItemType SalesChannel
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	7.4 KiB

Beverages	97
Vegetables	94
Office Supplies	84
Personal Care	83
Baby Food	79
Other values (7)	495

Length

Max length	15
Median length	13
Mean length	8.7854077
Min length	4

Characters and Unicode

Total characters	8188
Distinct characters	31
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cosmetics
2nd row	Vegetables
3rd row	Baby Food
4th row	Cereal
5th row	Fruits

Common Values

Value	Count	Frequency (%)
Beverages	97	10.4%
Vegetables	94	10.1%
Office Supplies	84	9.0%
Personal Care	83	8.9%
Baby Food	79	8.5%
Snacks	74	7.9%
Household	73	7.8%
Clothes	71	7.6%
Meat	71	7.6%
Cereal	70	7.5%
Other values (2)	136	14.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
beverages	97	8.2%
vegetables	94	8.0%
office	84	7.1%
supplies	84	7.1%
personal	83	7.0%
care	83	7.0%
baby	79	6.7%
food	79	6.7%
snacks	74	6.3%
household	73	6.2%
Other values (5)	348	29.5%

Most occurring characters

Value	Count	Frequency (%)
e	1331	16.3%
s	781	9.5%
a	651	8.0%
o	527	6.4%
l	475	5.8%
r	400	4.9%
t	372	4.5%
i	304	3.7%
C	293	3.6%
	246	3.0%
Other values (21)	2808	34.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8188	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1331	16.3%
s	781	9.5%
a	651	8.0%
o	527	6.4%
l	475	5.8%
r	400	4.9%
t	372	4.5%
i	304	3.7%
C	293	3.6%
	246	3.0%
Other values (21)	2808	34.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8188	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1331	16.3%
s	781	9.5%
a	651	8.0%
o	527	6.4%
l	475	5.8%
r	400	4.9%
t	372	4.5%
i	304	3.7%
C	293	3.6%
	246	3.0%
Other values (21)	2808	34.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8188	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1331	16.3%
s	781	9.5%
a	651	8.0%
o	527	6.4%
l	475	5.8%
r	400	4.9%
t	372	4.5%
i	304	3.7%
C	293	3.6%
	246	3.0%
Other values (21)	2808	34.3%

OrderPriority
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.4 KiB

Offline	483
Online	449

Length

Max length	7
Median length	7
Mean length	6.5182403
Min length	6

Characters and Unicode

Total characters	6075
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Offline
2nd row	Online
3rd row	Offline
4th row	Offline
5th row	Offline

Common Values

Value	Count	Frequency (%)
Offline	483	51.8%
Online	449	48.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
offline	483	51.8%
online	449	48.2%

Most occurring characters

Value	Count	Frequency (%)
n	1381	22.7%
f	966	15.9%
O	932	15.3%
l	932	15.3%
i	932	15.3%
e	932	15.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6075	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	1381	22.7%
f	966	15.9%
O	932	15.3%
l	932	15.3%
i	932	15.3%
e	932	15.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6075	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	1381	22.7%
f	966	15.9%
O	932	15.3%
l	932	15.3%
i	932	15.3%
e	932	15.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6075	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	1381	22.7%
f	966	15.9%
O	932	15.3%
l	932	15.3%
i	932	15.3%
e	932	15.3%

OrderID
Categorical

Distinct	4
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	7.4 KiB

L	249
C	247
M	229
H	207

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	932
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	C
4th row	C
5th row	H

Common Values

Value	Count	Frequency (%)
L	249	26.7%
C	247	26.5%
M	229	24.6%
H	207	22.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
l	249	26.7%
c	247	26.5%
m	229	24.6%
h	207	22.2%

Most occurring characters

Value	Count	Frequency (%)
L	249	26.7%
C	247	26.5%
M	229	24.6%
H	207	22.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	932	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
L	249	26.7%
C	247	26.5%
M	229	24.6%
H	207	22.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	932	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
L	249	26.7%
C	247	26.5%
M	229	24.6%
H	207	22.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	932	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
L	249	26.7%
C	247	26.5%
M	229	24.6%
H	207	22.2%

UnitsSold
Real number (ℝ)

UNIQUE

Distinct	932
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.4880586 × 10⁸

Minimum	1.0292801 × 10⁸
Maximum	9.9552983 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.4 KiB

Quantile statistics

Minimum	1.0292801 × 10⁸
5-th percentile	1.4669453 × 10⁸
Q1	3.2736753 × 10⁸
median	5.5410002 × 10⁸
Q3	7.6879841 × 10⁸
95-th percentile	9.4942607 × 10⁸
Maximum	9.9552983 × 10⁸
Range	8.9260182 × 10⁸
Interquartile range (IQR)	4.4143088 × 10⁸

Descriptive statistics

Standard deviation	2.5620493 × 10⁸
Coefficient of variation (CV)	0.46684074
Kurtosis	-1.1827043
Mean	5.4880586 × 10⁸
Median Absolute Deviation (MAD)	2.2089751 × 10⁸
Skewness	-0.022968805
Sum	5.1148706 × 10¹¹
Variance	6.5640968 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
686800706	1	0.1%
410231912	1	0.1%
798784863	1	0.1%
985092818	1	0.1%
325412309	1	0.1%
447917163	1	0.1%
903740775	1	0.1%
794969689	1	0.1%
584204280	1	0.1%
901180875	1	0.1%
Other values (922)	922	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
102928006	1	0.1%
103617227	1	0.1%
104845464	1	0.1%
105117976	1	0.1%
105390059	1	0.1%
105558288	1	0.1%
105966842	1	0.1%
106578814	1	0.1%
106753051	1	0.1%
107005393	1	0.1%

Value	Count	Frequency (%)
995529830	1	0.1%
994566810	1	0.1%
991644704	1	0.1%
990708720	1	0.1%
989928519	1	0.1%
989119565	1	0.1%
987714517	1	0.1%
986442506	1	0.1%
985665738	1	0.1%
985092818	1	0.1%

UnitPrice
Real number (ℝ)

HIGH CORRELATION

Distinct	896
Distinct (%)	96.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5055.0558

Minimum	13
Maximum	9998
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.4 KiB

Quantile statistics

Minimum	13
5-th percentile	445.4
Q1	2420.25
median	5202.5
Q3	7587.25
95-th percentile	9529.8
Maximum	9998
Range	9985
Interquartile range (IQR)	5167

Descriptive statistics

Standard deviation	2917.1905
Coefficient of variation (CV)	0.57708373
Kurtosis	-1.2341792
Mean	5055.0558
Median Absolute Deviation (MAD)	2568
Skewness	-0.053698272
Sum	4711312
Variance	8510000.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6283	3	0.3%
8128	2	0.2%
8775	2	0.2%
7913	2	0.2%
1578	2	0.2%
2352	2	0.2%
1547	2	0.2%
9669	2	0.2%
4247	2	0.2%
822	2	0.2%
Other values (886)	911	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13	1	0.1%
25	1	0.1%
33	1	0.1%
61	1	0.1%
64	1	0.1%
70	1	0.1%
80	1	0.1%
89	1	0.1%
103	1	0.1%
114	1	0.1%

Value	Count	Frequency (%)
9998	1	0.1%
9980	1	0.1%
9958	1	0.1%
9951	1	0.1%
9950	1	0.1%
9942	1	0.1%
9930	1	0.1%
9929	1	0.1%
9928	1	0.1%
9924	1	0.1%

UnitCost
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	261.49705

Minimum	9.33
Maximum	668.27
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.4 KiB

Quantile statistics

Minimum	9.33
5-th percentile	9.33
Q1	81.73
median	154.06
Q3	421.89
95-th percentile	668.27
Maximum	668.27
Range	658.94
Interquartile range (IQR)	340.16

Descriptive statistics

Standard deviation	217.41799
Coefficient of variation (CV)	0.83143573
Kurtosis	-0.74942399
Mean	261.49705
Median Absolute Deviation (MAD)	101.22
Skewness	0.79283801
Sum	243715.25
Variance	47270.582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
47.45	97	10.4%
154.06	94	10.1%
651.21	84	9.0%
81.73	83	8.9%
255.28	79	8.5%
152.58	74	7.9%
668.27	73	7.8%
109.28	71	7.6%
421.89	71	7.6%
205.7	70	7.5%
Other values (2)	136	14.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.33	67	7.2%
47.45	97	10.4%
81.73	83	8.9%
109.28	71	7.6%
152.58	74	7.9%
154.06	94	10.1%
205.7	70	7.5%
255.28	79	8.5%
421.89	71	7.6%
437.2	69	7.4%

Value	Count	Frequency (%)
668.27	73	7.8%
651.21	84	9.0%
437.2	69	7.4%
421.89	71	7.6%
255.28	79	8.5%
205.7	70	7.5%
154.06	94	10.1%
152.58	74	7.9%
109.28	71	7.6%
81.73	83	8.9%

Total
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	184.75343

Minimum	6.92
Maximum	524.96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.4 KiB

Quantile statistics

Minimum	6.92
5-th percentile	6.92
Q1	35.84
median	97.44
Q3	263.33
95-th percentile	524.96
Maximum	524.96
Range	518.04
Interquartile range (IQR)	227.49

Descriptive statistics

Standard deviation	176.20627
Coefficient of variation (CV)	0.95373747
Kurtosis	-0.61295248
Mean	184.75343
Median Absolute Deviation (MAD)	61.98
Skewness	0.94731478
Sum	172190.2
Variance	31048.651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
31.79	97	10.4%
90.93	94	10.1%
524.96	84	9.0%
56.67	83	8.9%
159.42	79	8.5%
97.44	74	7.9%
502.54	73	7.8%
35.84	71	7.6%
364.69	71	7.6%
117.11	70	7.5%
Other values (2)	136	14.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.92	67	7.2%
31.79	97	10.4%
35.84	71	7.6%
56.67	83	8.9%
90.93	94	10.1%
97.44	74	7.9%
117.11	70	7.5%
159.42	79	8.5%
263.33	69	7.4%
364.69	71	7.6%

Value	Count	Frequency (%)
524.96	84	9.0%
502.54	73	7.8%
364.69	71	7.6%
263.33	69	7.4%
159.42	79	8.5%
117.11	70	7.5%
97.44	74	7.9%
90.93	94	10.1%
56.67	83	8.9%
35.84	71	7.6%

Revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	931
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1326361.3

Minimum	2043.25
Maximum	6617209.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.4 KiB

Quantile statistics

Minimum	2043.25
5-th percentile	36638.91
Q1	266243.72
median	739383.6
Q3	1768543.1
95-th percentile	4750751.3
Maximum	6617209.5
Range	6615166.3
Interquartile range (IQR)	1502299.3

Descriptive statistics

Standard deviation	1491698.5
Coefficient of variation (CV)	1.1246548
Kurtosis	1.9586406
Mean	1326361.3
Median Absolute Deviation (MAD)	588048.01
Skewness	1.6097719
Sum	1.2361687 × 10⁹
Variance	2.2251644 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90211.77	2	0.2%
3692591.2	1	0.1%
3738302.38	1	0.1%
460786.95	1	0.1%
852617.04	1	0.1%
355732.65	1	0.1%
54421.89	1	0.1%
3397058.28	1	0.1%
861563.52	1	0.1%
1707721.4	1	0.1%
Other values (921)	921	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2043.25	1	0.1%
2061.93	1	0.1%
2556.42	1	0.1%
2733.69	1	0.1%
3592.05	1	0.1%
4114.53	1	0.1%
5409.3	1	0.1%
7273.97	1	0.1%
7501.32	1	0.1%
7669.26	1	0.1%

Value	Count	Frequency (%)
6617209.54	1	0.1%
6557065.24	1	0.1%
6456747.15	1	0.1%
6424186.65	1	0.1%
6354579.43	1	0.1%
6306968.85	1	0.1%
6263026.44	1	0.1%
6216247.54	1	0.1%
6209287.35	1	0.1%
6207333.72	1	0.1%

TotalCost
Real number (ℝ)

HIGH CORRELATION

Distinct	931
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	937575.8

Minimum	1416.75
Maximum	5204978.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.4 KiB

Quantile statistics

Minimum	1416.75
5-th percentile	23194.373
Q1	160430.65
median	456653.72
Q3	1151713
95-th percentile	3696940.8
Maximum	5204978.4
Range	5203561.7
Interquartile range (IQR)	991282.37

Descriptive statistics

Standard deviation	1169022.2
Coefficient of variation (CV)	1.2468562
Kurtosis	2.4612689
Mean	937575.8
Median Absolute Deviation (MAD)	372660.5
Skewness	1.7810015
Sum	8.7382065 × 10⁸
Variance	1.3666129 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
66909.48	2	0.2%
2224085.18	1	0.1%
2811208.76	1	0.1%
308712.69	1	0.1%
544494.72	1	0.1%
238329.63	1	0.1%
40364.36	1	0.1%
2936483.88	1	0.1%
282562.56	1	0.1%
972247.22	1	0.1%
Other values (921)	921	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1416.75	1	0.1%
1529.32	1	0.1%
1896.08	1	0.1%
2027.56	1	0.1%
2664.2	1	0.1%
3051.72	1	0.1%
3624.06	1	0.1%
4193.28	1	0.1%
5043.63	1	0.1%
5232.64	1	0.1%

Value	Count	Frequency (%)
5204978.4	1	0.1%
5178730.4	1	0.1%
5084237.6	1	0.1%
5005493.6	1	0.1%
5003918.72	1	0.1%
4976151.08	1	0.1%
4930922.48	1	0.1%
4885277.76	1	0.1%
4854305.12	1	0.1%
4778652.86	1	0.1%

TotalProfit
Real number (ℝ)

HIGH CORRELATION

Distinct	931
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	388785.47

Minimum	532.61
Maximum	1726181.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.4 KiB

Quantile statistics

Minimum	532.61
5-th percentile	10260.918
Q1	94933.545
median	272935.17
Q3	550521.42
95-th percentile	1235843.6
Maximum	1726181.4
Range	1725648.8
Interquartile range (IQR)	455587.87

Descriptive statistics

Standard deviation	381946.21
Coefficient of variation (CV)	0.98240865
Kurtosis	1.4517228
Mean	388785.47
Median Absolute Deviation (MAD)	207071.82
Skewness	1.3680055
Sum	3.6234805 × 10⁸
Variance	1.458829 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23302.29	2	0.2%
1468506.02	1	0.1%
927093.62	1	0.1%
152074.26	1	0.1%
308122.32	1	0.1%
117403.02	1	0.1%
14057.53	1	0.1%
460574.4	1	0.1%
579000.96	1	0.1%
735474.18	1	0.1%
Other values (921)	921	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
532.61	1	0.1%
626.5	1	0.1%
660.34	1	0.1%
706.13	1	0.1%
927.85	1	0.1%
1062.81	1	0.1%
1785.24	1	0.1%
1937.64	1	0.1%
1981.02	1	0.1%
2154.49	1	0.1%

Value	Count	Frequency (%)
1726181.36	1	0.1%
1725485.88	1	0.1%
1697666.68	1	0.1%
1682887.73	1	0.1%
1641058.46	1	0.1%
1631422.21	1	0.1%
1626142.76	1	0.1%
1587954.71	1	0.1%
1575926.57	1	0.1%
1571089.32	1	0.1%

order_date
Date

Distinct	317
Distinct (%)	34.2%
Missing	4
Missing (%)	0.4%
Memory size	7.4 KiB

Minimum	2022-01-11 00:00:00
Maximum	2023-04-30 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Auto

Heatmap
Table

	UnitsSold	ItemType SalesChannel	OrderID	OrderPriority	Revenue	Total	TotalCost	TotalProfit	UnitCost	UnitPrice
UnitsSold	1.000	0.026	0.000	0.076	-0.014	-0.039	-0.021	0.000	-0.028	0.008
ItemType SalesChannel	0.026	1.000	0.000	0.103	0.345	0.997	0.354	0.336	0.997	0.000
OrderID	0.000	0.000	1.000	0.029	0.000	0.000	0.027	0.007	0.034	0.066
OrderPriority	0.076	0.103	0.029	1.000	0.040	0.071	0.058	0.059	0.080	0.056
Revenue	-0.014	0.345	0.000	0.040	1.000	0.747	0.988	0.946	0.753	0.584
Total	-0.039	0.997	0.000	0.071	0.747	1.000	0.783	0.610	0.972	0.015
TotalCost	-0.021	0.354	0.027	0.058	0.988	0.783	1.000	0.892	0.769	0.554
TotalProfit	0.000	0.336	0.007	0.059	0.946	0.610	0.892	1.000	0.659	0.622
UnitCost	-0.028	0.997	0.034	0.080	0.753	0.972	0.769	0.659	1.000	0.010
UnitPrice	0.008	0.000	0.066	0.056	0.584	0.015	0.554	0.622	0.010	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Region	Country	ItemType SalesChannel	OrderPriority	OrderID	UnitsSold	UnitPrice	UnitCost	Total	Revenue	TotalCost	TotalProfit	order_date
0	Middle East and North Africa	Libya	Cosmetics	Offline	M	686800706	8446	437.20	263.33	3692591.20	2224085.18	1468506.02	2023-02-13
1	North America	Canada	Vegetables	Online	M	185941302	3018	154.06	90.93	464953.08	274426.74	190526.34	2023-03-28
2	Middle East and North Africa	Libya	Baby Food	Offline	C	246222341	1517	255.28	159.42	387259.76	241840.14	145419.62	2022-09-08
3	Asia	Japan	Cereal	Offline	C	161442649	3322	205.70	117.11	683335.40	389039.42	294295.98	2023-01-07
4	Sub-Saharan Africa	Chad	Fruits	Offline	H	645713555	9845	9.33	6.92	91853.85	68127.40	23726.45	2022-04-23
5	Europe	Armenia	Cereal	Online	H	683458888	9528	205.70	117.11	1959909.60	1115824.08	844085.52	2022-06-20
6	Sub-Saharan Africa	Eritrea	Cereal	Online	H	679414975	2844	205.70	117.11	585010.80	333060.84	251949.96	2022-08-09
7	Europe	Montenegro	Clothes	Offline	M	208630645	7299	109.28	35.84	797634.72	261596.16	536038.56	2023-04-06
8	Central America and the Caribbean	Jamaica	Vegetables	Online	H	266467225	2428	154.06	90.93	374057.68	220778.04	153279.64	2022-06-05
9	Australia and Oceania	Fiji	Vegetables	Offline	H	118598544	4800	154.06	90.93	739488.00	436464.00	303024.00	2023-02-13

	Region	Country	ItemType SalesChannel	OrderPriority	OrderID	UnitsSold	UnitPrice	UnitCost	Total	Revenue	TotalCost	TotalProfit	order_date
922	9Australia and Oceania	Fiji	Cereal	Online	L	903278148	8932	205.70	117.11	1837312.40	1046026.52	791285.88	2023-02-08
923	0Sub-Saharan Africa	Mali	Beverages	Online	L	410452497	870	47.45	31.79	41281.50	27657.30	13624.20	2023-04-20
924	1Sub-Saharan Africa	Liberia	Cereal	Offline	H	642683303	3126	205.70	117.11	643018.20	366085.86	276932.34	2022-06-07
925	2Europe	Switzerland	Beverages	Offline	L	682831895	3987	47.45	31.79	189183.15	126746.73	62436.42	2022-10-12
926	3Australia and Oceania	Samoa	Baby Food	Online	L	584072101	8769	255.28	159.42	2238550.32	1397953.98	840596.34	2022-05-12
927	4Asia	Nepal	Meat	Offline	C	919890248	4821	421.89	364.69	2033931.69	1758170.49	275761.20	2022-02-21
928	5Middle East and North Africa	Azerbaijan	Snacks	Offline	C	534085166	6524	152.58	97.44	995431.92	635698.56	359733.36	2022-11-06
929	6Europe	Georgia	Baby Food	Offline	H	590768182	288	255.28	159.42	73520.64	45912.96	27607.68	2022-10-07
930	7Middle East and North Africa	United Arab Emirates	Vegetables	Online	C	524363124	9556	154.06	90.93	1472197.36	868927.08	603270.28	2022-08-20
931	9Europe	Portugal	Cereal	Offline	C	811546599	3528	205.70	117.11	725709.60	413164.08	312545.52	2022-06-30

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample